package com.bos.mapper;

import com.bos.data.model.BosProjectModel;
import com.bos.data.model.BusinessModel;
import com.bos.data.model.PerformanceModel;
import com.bos.data.model.SituationModel;
import org.apache.ibatis.annotations.Select;

import java.util.List;

/**
 * create by tanghuihong 2018/6/13
 */
public interface PerformanceMapper {
    //1.查询出项目表中的数据
    @Select("select * from bos_project where id=#{id}")
    public BosProjectModel findProjectDetails(int id);
    //2.查询出实施情况中的数据
    @Select("select a.*,b.* from bos_project  a left JOIN Performance b on a.id=b.pid WHERE a.id=#{id}")
    public  PerformanceModel findPerformances(int id);
    //3.查询出商务情况中的数据
    @Select("select a.*,b.* from bos_project  a left JOIN Business b on a.id=b.pid WHERE a.id=#{id}")
    public BusinessModel findBuiness(int id);
}
